// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   check_ok.java

package qcs.solution;

import com.jspsmart.upload.*;
import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import java.io.File;
import java.io.IOException;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;

public class check_ok extends HttpServlet
{

	public check_ok()
	{
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			ServletContext context = session.getServletContext();
			String path = context.getRealPath("/");
			counter count = new counter(dbApplication);
			SmartUpload mySmartUpload = new SmartUpload();
			mySmartUpload.setCharset("UTF-8");
			nseer_db_backup1 qcs_db = new nseer_db_backup1(dbApplication);
			if (qcs_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				mySmartUpload.initialize(pageContext);
				String file_type = getFileLength.getFileType((String)session.getAttribute("unit_db_name"));
				long d = getFileLength.getFileLength((String)session.getAttribute("unit_db_name"));
				mySmartUpload.setMaxFileSize(d);
				mySmartUpload.setAllowedFilesList(file_type);
				try
				{
					mySmartUpload.upload();
					String item[] = mySmartUpload.getRequest().getParameterValues("item");
					if (item != null)
					{
						String file_name[] = new String[mySmartUpload.getFiles().getCount()];
						String not_change[] = new String[mySmartUpload.getFiles().getCount()];
						Date now = new Date();
						SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
						String time = formatter.format(now);
						String solution_id = mySmartUpload.getRequest().getParameter("solution_id");
						String config_id = request.getParameter("config_id");
						String sql6 = (new StringBuilder("select id from qcs_workflow where object_ID='")).append(solution_id).append("' and ((check_tag='0' and config_id<'").append(config_id).append("') or (check_tag='1' and config_id='").append(config_id).append("'))").toString();
						ResultSet rs6 = qcs_db.executeQuery(sql6);
						if (!rs6.next())
						{
							String sql1 = (new StringBuilder("select attachment1 from qcs_solution where solution_id='")).append(solution_id).append("' and check_tag='0'").toString();
							ResultSet rs = qcs_db.executeQuery(sql1);
							if (!rs.next())
							{
								response.sendRedirect("qcs/solution/check_ok.jsp?finished_tag=0");
							} else
							{
								String attachment[] = mySmartUpload.getRequest().getParameterValues("attachment");
								String delete_file_name[] = new String[0];
								if (attachment != null)
								{
									delete_file_name = new String[attachment.length];
									for (int i = 0; i < attachment.length; i++)
										delete_file_name[i] = rs.getString(attachment[i]);

								}
								for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
								{
									SmartFile file = mySmartUpload.getFiles().getFile(i);
									if (file.isMissing())
									{
										file_name[i] = "";
										int q = i + 1;
										String field_name = (new StringBuilder("attachment")).append(q).toString();
										if (!rs.getString(field_name).equals(""))
											not_change[i] = "yes";
									} else
									{
										int filenum = count.read((String)dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount");
										count.write((String)dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount", filenum);
										file_name[i] = (new StringBuilder(String.valueOf(filenum))).append(file.getFileName()).toString();
										file.saveAs((new StringBuilder(String.valueOf(path))).append("qcs/file_attachments/").append(filenum).append(file.getFileName()).toString());
									}
								}

								String solution_name = mySmartUpload.getRequest().getParameter("solution_name");
								String product_id = mySmartUpload.getRequest().getParameter("product_id");
								String product_name = mySmartUpload.getRequest().getParameter("product_name");
								String designer = mySmartUpload.getRequest().getParameter("designer");
								String checker = mySmartUpload.getRequest().getParameter("checker");
								String checker_id = mySmartUpload.getRequest().getParameter("checker_id");
								String check_time = mySmartUpload.getRequest().getParameter("check_time");
								String quality_standard = mySmartUpload.getRequest().getParameter("quality_standard");
								String quality_standard_id = quality_standard.split("/")[0];
								String quality_standard_name = quality_standard.split("/")[1];
								String bodyab = new String(mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8");
								String remark = exchange.toHtml(bodyab);
								String sqla = (new StringBuilder("update qcs_solution set solution_name='")).append(solution_name).append("',quality_standard_id='").append(quality_standard_id).append("',quality_standard_name='").append(quality_standard_name).append("',product_id='").append(product_id).append("',product_name='").append(product_name).append("',designer='").append(designer).append("',checker='").append(checker).append("',checker_id='").append(checker_id).append("',check_time='").append(check_time).append("',remark='").append(remark).append("'").toString();
								String sqlb = (new StringBuilder(" where solution_id='")).append(solution_id).append("'").toString();
								if (attachment != null)
								{
									for (int i = 0; i < attachment.length; i++)
									{
										sqla = (new StringBuilder(String.valueOf(sqla))).append(",").append(attachment[i]).append("=''").toString();
										File file = new File((new StringBuilder(String.valueOf(path))).append("qcs/file_attachments/").append(delete_file_name[i]).toString());
										file.delete();
									}

								}
								for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
									if (not_change[i] == null || !not_change[i].equals("yes"))
									{
										int p = i + 1;
										sqla = (new StringBuilder(String.valueOf(sqla))).append(",attachment").append(p).append("='").append(file_name[i]).append("'").toString();
									}

								String sql = (new StringBuilder(String.valueOf(sqla))).append(sqlb).toString();
								qcs_db.executeUpdate(sql);
								sql = (new StringBuilder("delete from qcs_solution_details where solution_id='")).append(solution_id).append("'").toString();
								qcs_db.executeUpdate(sql);
								String analyse_method[] = mySmartUpload.getRequest().getParameterValues("analyse_method");
								String default_basis[] = mySmartUpload.getRequest().getParameterValues("default_basis");
								String ready_basis[] = mySmartUpload.getRequest().getParameterValues("ready_basis");
								String quality_method[] = mySmartUpload.getRequest().getParameterValues("quality_method");
								String standard_value[] = mySmartUpload.getRequest().getParameterValues("standard_value");
								String standard_max[] = mySmartUpload.getRequest().getParameterValues("standard_max");
								String standard_min[] = mySmartUpload.getRequest().getParameterValues("standard_min");
								for (int i = 0; i < item.length; i++)
									if (!item[i].equals(""))
									{
										sql = (new StringBuilder("insert into qcs_solution_details(solution_id,solution_name,details_number,item,analyse_method,default_basis,ready_basis,quality_method,standard_value,standard_max,standard_min) values('")).append(solution_id).append("','").append(solution_name).append("','").append(i).append("','").append(item[i]).append("','").append(analyse_method[i]).append("','").append(default_basis[i]).append("','").append(ready_basis[i]).append("','").append(quality_method[i]).append("','").append(standard_value[i]).append("','").append(standard_max[i]).append("','").append(standard_min[i]).append("')").toString();
										qcs_db.executeUpdate(sql);
									}

								sql = (new StringBuilder("update qcs_workflow set checker='")).append(checker).append("',checker_ID='").append(checker_id).append("',check_time='").append(check_time).append("',check_tag='1' where object_ID='").append(solution_id).append("' and config_id='").append(config_id).append("'").toString();
								qcs_db.executeUpdate(sql);
								sql = (new StringBuilder("select id from qcs_workflow where object_ID='")).append(solution_id).append("' and check_tag='0'").toString();
								ResultSet rset = qcs_db.executeQuery(sql);
								if (!rset.next())
								{
									sql = (new StringBuilder("update qcs_solution set check_tag='1' where solution_id='")).append(solution_id).append("' and check_tag='0'").toString();
									qcs_db.executeUpdate(sql);
								}
								response.sendRedirect("qcs/solution/check_ok.jsp?finished_tag=2");
							}
						} else
						{
							response.sendRedirect("qcs/solution/check_ok.jsp?finished_tag=5");
						}
					} else
					{
						response.sendRedirect("qcs/solution/check_ok.jsp?finished_tag=4");
					}
				}
				catch (Exception ex)
				{
					ex.printStackTrace();
					response.sendRedirect("qcs/solution/check_ok.jsp?finished_tag=3");
				}
				qcs_db.commit();
				qcs_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
